package org.jeecg.modules.app.v1.shop.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.app.v1.shop.entity.ApiBdEntity;

import java.util.List;

/**
 * 这里是一个注释
 *
 * @author scw
 * @version v1.0
 * @date
 */
public interface ApiSysUserMapper extends BaseMapper {

//    @Select(" SELECT case when phone is null then realname else CONCAT(realname,'|',IFNULL(phone,'')) end name,a.id  FROM sys_user a LEFT JOIN sys_user_role b on a.id = b.user_id where b.role_id = '1811671800946208769' and ( realname like CONCAT('%',#{name},'%') or phone like  CONCAT('%',#{name},'%') ) ")
    List<ApiBdEntity> getBdList(String name);

}
